﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Hierarchy.Master" AutoEventWireup="true" CodeBehind="displayEvaluation.aspx.cs" Inherits="AppraisalManagement.displayEvaluation" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">




    <asp:GridView ID="EvaluationGridView" runat="server" AllowPaging="True" 
        AllowSorting="True" AutoGenerateColumns="False" BackColor="White" 
        BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px" CellPadding="4" 
        DataSourceID="EvaluationDataSource" ForeColor="Black" GridLines="Vertical" 
        ShowFooter="True">
        <RowStyle BackColor="#F7F7DE" />
        <Columns>
            <asp:BoundField DataField="kpi_group_name" HeaderText="kpi_group_name" 
                SortExpression="kpi_group_name" />
            <asp:BoundField DataField="kpi_name" HeaderText="kpi_name" 
                SortExpression="kpi_name" />
            <asp:BoundField DataField="max_score" HeaderText="max_score" 
                SortExpression="max_score" />
            <asp:BoundField DataField="marks" HeaderText="marks" SortExpression="marks" />
            <asp:BoundField DataField="lst_modified_dt" HeaderText="lst_modified_dt" 
                SortExpression="lst_modified_dt" />
        </Columns>
        <FooterStyle BackColor="#CCCC99" />
        <PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" />
        <SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
        <AlternatingRowStyle BackColor="White" />
    </asp:GridView>
    <asp:SqlDataSource ID="EvaluationDataSource" runat="server" 
        ConnectionString="<%$ ConnectionStrings:balancescorecardConnectionString %>" 
        SelectCommand="SELECT kpi_group.kpi_group_name, kpi.kpi_name, Employee_KPI_Linking.max_score, emp_kpi_marks.marks, emp_kpi_marks.lst_modified_dt FROM Employee_KPI_Linking INNER JOIN kpi ON Employee_KPI_Linking.fk_kpi_pk = kpi.kpi_id_pk INNER JOIN kpi_group ON Employee_KPI_Linking.fk_kpi_group_pk = kpi_group.kpi_group_id_pk INNER JOIN emp_kpi_marks ON Employee_KPI_Linking.emp_kpi_pk = emp_kpi_marks.emp_kpi_pk_fk WHERE (Employee_KPI_Linking.fk_emp_pk = @empPk) ORDER BY emp_kpi_marks.lst_modified_dt desc, Employee_KPI_Linking.emp_kpi_pk asc">
        <SelectParameters>
            <asp:SessionParameter DefaultValue="1" Name="empPk" 
                SessionField="SELECTED_PK" />
        </SelectParameters>
    </asp:SqlDataSource>




</asp:Content>
